<?php
namespace app\common\model;
use think\Db;
use think\Model;

/**
 * 用户设备绑定记录
 * @author lcx
 * @date 2018-08-20
 */
class CustomerBindEquipment extends Model {

    // 表名
    protected $name = 'customer_bind_equipment';

    // 列表查询
    public function getAll($where, $join, $page, $pageSize, $field, $order) {
        if($pageSize>0){
            $result = $this->where($where)
                ->join($join)
                ->field($field)
                ->page($page, $pageSize)
                ->order($order)
                ->select();
        }else{
            $result = $this->where($where)
                ->join($join)
                ->field($field)
                ->order($order)
                ->select();
        }
        
        return $result;
    }

    // 数量查询
    public function getCount($where, $join, $dbName='') {
        $result = $this->where($where)
                ->join($join)
                ->count();
        return $result;
    }

    // 单个查询
    public function getOne($where, $join, $field,$dbName='') {
        $result = $this->alias('ce')->where($where)
                ->join($join)
                ->field($field)
                ->find();
        return $result;
    }
     // 添加操作
    public function add($data)
    {
        $result = $this->insertGetId($data);
        return $result;
    }

    // 编辑操作
    public function edit($where, $data)
    {
        $result = $this->where($where)->update($data);
        return $result;
    }

}
